home *** CD-ROM | disk | FTP | other *** search
/ Amiga Plus 2002 #11 / Amiga Plus CD - 2002 - No. 11.iso / amigaoscd / amigapluscd / AP-Website / news / admin / change_news.php < prev    next >
Text File  |  2002-01-27  |  4KB  |  126 lines
  1. <html>
  2. <head>
  3. <title>AmigaPlus News Admin</title>
  4. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  5. </head>
  6.  
  7. <body bgcolor="#66CCFF" text="#000000">
  8. <?php
  9.     
  10.     $server = "db04.puretec.de";
  11.     $db = "db24905524";
  12.     $login = "p343302";
  13.     $pass = "90f42902";
  14.     
  15.     $dbwww = mysql_connect($server,$login,$pass);
  16.     mysql_select_db($db,$dbwww);
  17.     
  18.     $query = "select * from amigaplusnews_content where id = $newsentry limit 1";
  19.     $query_result = mysql_query($query,$dbwww);
  20.     list($id,$timestamp,$title,$link,$source,$text,$category,$author,$target,$visible) = mysql_fetch_row($query_result);
  21.     
  22. ?>
  23.  
  24. <p><b><font size="+1">AmigaPlus News Admin</font></b></p>
  25. <p><a href="index.php">zurück</a></p>
  26. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  27.   <tr>
  28.     <td bgcolor="#0099FF"><b>News ändern</b></td>
  29.   </tr>
  30.   <tr>
  31.     <td>
  32.       <form name="update_news" method="post" action="update_news.php">
  33.       <input type="hidden" name="id" value="<?php echo $id ?>">
  34.         <table width="100%" border="0" cellspacing="0" cellpadding="0">
  35.           <tr> 
  36.             <td width="150" valign="top"> 
  37.               <div align="left">Überschrift</div>
  38.             </td>
  39.             <td> 
  40.               <input type="text" name="title" size="50" maxlength="200" value="<?php echo $title ?>">
  41.             </td>
  42.           </tr>
  43.           <tr> 
  44.             <td width="150" valign="top"> 
  45.               <div align="left">
  46.                 <p>Newstext</p>
  47.                 <p><font size="-1">Zeilenumbrüche nur machen wenn auch wirklich 
  48.                   ein Absatz erscheinen soll in den News.</font></p>
  49.               </div>
  50.             </td>
  51.             <td> 
  52.               <textarea name="newstext" cols="70" rows="10" wrap="VIRTUAL"><?php echo $text ?></textarea>
  53.             </td>
  54.           </tr>
  55.           <tr> 
  56.             <td width="150" valign="top"> 
  57.               <div align="left">Link</div>
  58.             </td>
  59.             <td> 
  60.               <input type="text" name="link" size="50" maxlength="200" value="<?php echo $link ?>">
  61.             </td>
  62.           </tr>
  63.           <tr> 
  64.             <td width="150" valign="top"> 
  65.               <div align="left">Quelle</div>
  66.             </td>
  67.             <td> 
  68.               <input type="text" name="source" size="50" maxlength="100" value="<?php echo $source ?>">
  69.             </td>
  70.           </tr>
  71.           <tr> 
  72.             <td width="150" valign="top"> 
  73.               <div align="left">Autor</div>
  74.             </td>
  75.             <td> 
  76.               <select name="author">
  77.               <?php
  78.                 $query = "select * from amigaplusnews_authors order by short_name asc";
  79.                 $query_result = mysql_query($query,$dbwww);
  80.                 while($row = mysql_fetch_array($query_result))
  81.                 {
  82.                     ?>
  83.                     <option value="<?php echo $row["id"] ?>" <?php if($row["id"]==$author) { echo "selected"; } ?>><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option> 
  84.                     <?php
  85.                 }
  86.               ?>
  87.               </select>
  88.             </td>
  89.           </tr>
  90.           <tr> 
  91.             <td width="150" valign="top"> 
  92.               <div align="left">Kategorie</div>
  93.             </td>
  94.             <td> 
  95.               <select name="category">
  96.               <?php
  97.                 $query = "select * from amigaplusnews_categories order by name asc";
  98.                 $query_result = mysql_query($query,$dbwww);
  99.                 while($row = mysql_fetch_array($query_result))
  100.                 {
  101.                     ?>
  102.                     <option value="<?php echo $row["id"] ?>" <?php if($category==$row["id"]) { echo "selected"; } ?>><?php echo $row["name"] ?></option> 
  103.                     <?php
  104.                 }
  105.               ?>
  106.               </select>
  107.             </td>
  108.           </tr>
  109.           <tr> 
  110.             <td width="150" valign="top"> 
  111.               <div align="left">Zielframe/fenster</div>
  112.             </td>
  113.             <td> 
  114.               <input type="text" name="target" value="_blank" maxlength="100" value="<?php echo $target ?>">
  115.             </td>
  116.           </tr>
  117.         </table>
  118.         <input type="submit" name="submit" value="speichern">
  119.       </form>
  120.     </td>
  121.   </tr>
  122. </table>
  123. <p> </p>
  124. </body>
  125. </html>
  126.